eQL Mapping Examples
Below are eQL Mapping statement examples.
|
Input Examples {<start_with_object>|<select_data_field>}
|
eQL /Search starts with |
|---|---|
{DistributionOrder|Organization.Code}
|
START WITH DistributionOrder
SELECT Organization.Code |
{DistributionOrder|Attribute["ABC”,"XYZ"].Value}
|
START WITH DistributionOrder
SELECT Attributes["ABC", "XYZ"].Value |
{Transmittal|Code}
|
START WITH Transmittal
SELECT Code |
{Transmittal|LineItems.Project.Code}
|
START WITH Transmittal
SELECT LineItems.Project.Code |
{Transmittal|IssuedTo.FirstName+''+IssuedTo.Surname}
|
START WITH Transmittal
SELECT IssuedTo.FirstName + ' ' + IssuedTo.Surname |
{TransmittalItem|Projects.Project.Code}
|
START WITH Document
SELECT Projects.Project.Code |
{TransmittalItemFile|Name|Id = 2 }
|
START WITH Files
SELECT Name WHERE Id = 2 |